package org.springblade.modules.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.springblade.modules.system.entity.Doctor;

import java.util.List;

public interface DoctorMapper extends BaseMapper<Doctor> {
	int countByExample(@Param("doctorName") String doctorName, @Param("createTimeMax") String createTimeMax, @Param("createTimeMin") String createTimeMin);

	int Count();

	List<Doctor> selectByLimitPage(@Param("doctorName") String doctorName, @Param("createTimeMax") String createTimeMax, @Param("createTimeMin") String createTimeMin, @Param("offset") int offset, @Param("limit") int pageSize);

	/**
	 * 获取列表
	 */
	List<Doctor> openDoctorTable(@Param("doctorName") String doctorName, int currentPage, int pageSize) throws Exception;

	/**
	 * 查询所有信息
	 */
	List<Doctor> selectAllDoctor();

	/**
	 * 删除信息
	 */
	int deleteDoctorById(Integer id);

	/**
	 * 多删除
	 */
	int deleteByPrimaryKey(List<Integer> ids);

	/**
	 * 添加
	 */
	public int addDoctor(Doctor doctor);

	/**
	 * 修改
	 */
	public int updateDoctor(Doctor doctor);

	/**
	 * 根据ID查询
	 */
	public Doctor findById(@Param("id") Integer id);

	/**
	 * 根据类别查询
	 */
	public int findByType(List<Integer> typeid);

}
